USE NGroup_VTL_DB
GO

ALTER TABLE [NGroup_VTL_DB].[dbo].[Products]
ADD 
[Title_En]				[nvarchar](500) NOT NULL DEFAULT(''),
[Content_En]			[nvarchar](max) NOT NULL DEFAULT(''),
[ProductDetail_En]		[nvarchar](max) NULL,
[MetaContent_En]		[nvarchar](1500) NULL,
[Price_En]				[nvarchar](100) NULL,
[ImageSmallURL_En]		[nvarchar](500) NULL,
[ImageLargeURL_En]		[nvarchar](500) NULL
GO

UPDATE [NGroup_VTL_DB].[dbo].[Products]
   SET [Title_En] = [Title] + ' (English)'
      ,[Content_En] = [Content]
      ,[ProductDetail_En] = [ProductDetail]
      ,[MetaContent_En] = [MetaContent]
      ,[Price_En] = [Price]
      ,[ImageSmallURL_En] = [ImageSmallURL]
      ,[ImageLargeURL_En] = [ImageLargeURL]
 WHERE 1 = 1